Install the Power BI Connector

The Power BI Connector is a SysTrack Kit, named SysTrack PowerBI. You must import this Kit before you can complete the steps in the following sections.

IMPORTANT: You can download the Kit on the DEX and Kit Downloads page.

Run the Automation for the Connector

The Kit named SysTrack PowerBI includes an automation named InstallLakesidePowerBICertificate. You can find and configure the automation in SysTrack Configure.

Before you can run the automation, follow these steps:

  1. At Configure > Automations and Collection Extensions > Automations (tab), edit the Automation. Select the operating system you want in the Operating System field.

  2. At Configure > Automations and Collection Extensions > Action Governance (tab), select the Automation. Then Approve and Enable it.

    The Automation must be Approved and Enabled before you can use it. To check whether it has been approved, select the Automations tab, and look at the Approved? and Enabled? fields (under Action Details).

  3. In the Description field, add a Description (which is optional) to remind everyone of this automation's purpose.

When you are ready to run the automation for the Connector, you can run the automation with one of these methods:

TIP: The SysTrack agent reads the configuration changes, and then the automation will appear in Resolve. If you need to expedite this process, you can force a Read Configuration to the endpoint and wait a few minutes for the automation to appear.

When you run the InstallLakesidePowerBICertificate automation, it installs the Lakeside Signed Certificate.

After you run the automation, you are ready to install the Custom Connector PQX in the following section. Then you can use the connector in Power BI.

If you prefer to manually install the Lakeside Signed Certificate, you can follow these steps.

Install the Custom Connector PQX

In your documents folder, you should see the path Power BI Desktop > Custom Connectors.

  1. If the folder does not exist, create it.

    pqx file location

  2. Copy the LakesidePowerBIConnector.pqx into the Custom Connectors folder.

NOTE: If you use OneDrive, make sure you copy the LakesidePowerBIConnector.pqx into the Custom Connectors folder that Power BI accesses. The folder path could be:

C:\Users\<YourUsername>\Documents\Power BI Desktop\Custom Connectors

Or if the Documents folder is part of your OneDrive path, the path could be:

C:\Users\<YourUsername>\OneDrive\Documents\Power BI Desktop\Custom Connectors

Ensure that your Custom Connectors folder is synced and available offline.

Manually Install the Lakeside Signed Certificate

If you prefer to install the Certificate manually, you can use the following steps.

IMPORTANT: The best practice is to run the InstallLakesidePowerBICertificate automation, which completes the following steps for you.

  1. Install Power BI Desktop based on your processor type.

  2. To add the certificate thumbprint to the registry, go to HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Power BI Desktop.

  3. If the folder does not exist, right-click the Microsoft folder and select New > Key.

  4. Name the folder Power BI Desktop.

  5. If the Power BI Desktop folder does exist, select New > Multi-String Value.

  6. Select REG_MULTI_SZ, and name it TrustedCertificateThumbprints.

  7. Enter the thumbprint: E820602155DC57E2981197005D46D78E7E4503DF

  8. You might get the following warning:

  9. If you have entered the thumbprint correctly (with no blank line after it), click OK.